3c72c49aec83649cfa01adec93eb937d7950c9fe,yamj3-core/src/main/java/org/yamj/core/database/dao/ApiDao.java,ApiDao,getSqlArtwork,#OptionsIndexArtwork#,1342

Before Change


        sqlScalars.addToSql("ag.id AS generatedId,");
        sqlScalars.addToSql("a.season_id AS seasonId,");
        sqlScalars.addToSql("a.series_id AS seriesId,");
        sqlScalars.addToSql("a.videodata_id AS videodataId,");
        sqlScalars.addToSql("a.artwork_type AS artworkType,");
        sqlScalars.addToSql("ag.cache_filename AS cacheFilename,");
        sqlScalars.addToSql("ag.cache_dir AS cacheDir");
        sqlScalars.addToSql("FROM artwork a");
        sqlScalars.addToSql(SQL_LEFT_JOIN_ARTWORK_LOCATED);
        sqlScalars.addToSql(SQL_LEFT_JOIN_ARTWORK_GENERATED);

After Change


        sqlScalars.addToSql("FROM artwork a");
        sqlScalars.addToSql(SQL_LEFT_JOIN_ARTWORK_LOCATED);
        sqlScalars.addToSql(SQL_LEFT_JOIN_ARTWORK_GENERATED);
        sqlScalars.addToSql("WHERE 1=1");
        
        if (options.getId() > 0L) {
            sqlScalars.addToSql("AND a.id=:id");